Customer Transactions Report

If this were a real report I would welcome the reader here and provide any context they require.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

Distribution of overdraft limits

Relationship between account open and close dates

As can be seen in Figure 1, the rate of new accounts being opened is on a downward trend.

Figure 1: Number of accounts opening per month after adjusting for account closures

The trend is because while the number of accounts being opened between 2002 and 2018 have remained roughly steady, during the same period the number of accounts closing each month has been slowly rising, as seen in Figure 2.

Figure 2: Number of accounts opening (top line) and closing (bottom line) per month

Customers

Highest transaction value

The customer with the highest overall transaction value is account number 11336875, with £423,496.

Highest number of transactions

The 10 customers with the highest number of transactions are

tinytable_69jcalgjkrtaae2cu4lr
Account Number Transactions Count
11336875 693
12402243 686
10322173 500
12644022 472
10250507 468
10143829 426
11850488 424
10709272 421
12822022 402
11358265 386

Lowest transaction value

The customer with the lowest overall transaction value is account number 12857039, with £-50,165.

Transactions per month

tinytable_gaft34e6gppb9xy3iqde
Number Customers Month
3,787 Jan 2018
3,687 Feb 2018
3,846 Mar 2018
3,776 Apr 2018
3,797 May 2018
3,782 Jun 2018
3,826 Jul 2018
3,776 Aug 2018
3,758 Sep 2018
3,845 Oct 2018
3,157 Nov 2018

No transactions

There are 3,463 customers with no transactions.